/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : ruyuan_eshop_action02

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 18/10/2021 14:42:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for es_as_change
-- ----------------------------
DROP TABLE IF EXISTS `es_as_change`;
CREATE TABLE `es_as_change` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `service_sn` varchar(50) DEFAULT NULL COMMENT '售后服务单号',
  `ship_name` varchar(50) DEFAULT NULL COMMENT '收货人姓名',
  `province_id` bigint(20) DEFAULT NULL COMMENT '收货地址省份id',
  `city_id` bigint(20) DEFAULT NULL COMMENT '收货地址城市id',
  `county_id` bigint(20) DEFAULT NULL COMMENT '收货地址区县id',
  `town_id` bigint(20) DEFAULT NULL COMMENT '收货地址城镇id',
  `province` varchar(255) DEFAULT NULL COMMENT '收货地址省份名称',
  `city` varchar(255) DEFAULT NULL COMMENT '收货地址城市名称',
  `county` varchar(255) DEFAULT NULL COMMENT '收货地址县(区)名称',
  `town` varchar(255) DEFAULT NULL COMMENT '收货地址城镇名称',
  `ship_addr` varchar(255) DEFAULT NULL COMMENT '收货地址',
  `ship_mobile` varchar(50) DEFAULT NULL COMMENT '收货人手机号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SERVICE_SN` (`service_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='售后服务用户收货地址信息表(es_as_change)';

-- ----------------------------
-- Records of es_as_change
-- ----------------------------
BEGIN;
INSERT INTO `es_as_change` VALUES (1, 'AS197966109935661057', '张三', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '青海大道101号', '13845365567', '2021-10-15 17:50:26', '2021-10-15 17:50:26');
COMMIT;

-- ----------------------------
-- Table structure for es_as_express
-- ----------------------------
DROP TABLE IF EXISTS `es_as_express`;
CREATE TABLE `es_as_express` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `service_sn` varchar(50) DEFAULT NULL COMMENT '售后服务单号',
  `courier_number` varchar(255) DEFAULT NULL COMMENT '物流单号',
  `courier_company_id` bigint(20) DEFAULT NULL COMMENT '物流公司id',
  `courier_company` varchar(255) DEFAULT NULL COMMENT '物流公司名称',
  `ship_time` bigint(20) DEFAULT NULL COMMENT '发货时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SERVICE_SN` (`service_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='售后服务用户退还商品物流信息表(es_as_express)';

-- ----------------------------
-- Records of es_as_express
-- ----------------------------
BEGIN;
INSERT INTO `es_as_express` VALUES (1, 'AS197966109935661057', '123321', 12, '中通', 1632844800, '2021-10-15 18:19:15', '2021-10-15 18:19:15');
COMMIT;

-- ----------------------------
-- Table structure for es_as_gallery
-- ----------------------------
DROP TABLE IF EXISTS `es_as_gallery`;
CREATE TABLE `es_as_gallery` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `service_sn` varchar(50) DEFAULT NULL COMMENT '售后单号',
  `img` varchar(255) DEFAULT NULL COMMENT '图片链接',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SERVICE_SN` (`service_sn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='售后服务图片信息表(es_as_gallery)';

-- ----------------------------
-- Table structure for es_as_goods
-- ----------------------------
DROP TABLE IF EXISTS `es_as_goods`;
CREATE TABLE `es_as_goods` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `service_sn` varchar(50) DEFAULT NULL COMMENT '售后服务单号',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品ID',
  `sku_id` bigint(20) DEFAULT NULL COMMENT '商品SKUID',
  `ship_num` int(10) DEFAULT NULL COMMENT '发货数量',
  `price` decimal(20,2) DEFAULT NULL COMMENT '商品成交价',
  `return_num` int(10) DEFAULT NULL COMMENT '退还数量',
  `storage_num` int(10) DEFAULT NULL COMMENT '入库数量',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_sn` varchar(255) DEFAULT NULL COMMENT '商品编号',
  `goods_image` varchar(255) DEFAULT NULL COMMENT '商品缩略图',
  `spec_json` longtext COMMENT '商品规格信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SERVICE_SN` (`service_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='售后服务商品信息表(es_as_goods)';

-- ----------------------------
-- Records of es_as_goods
-- ----------------------------
BEGIN;
INSERT INTO `es_as_goods` VALUES (1, 'AS197966109935661057', 1417677439226580994, 1417746396428079105, 1, 6550.00, 1, 1, '鸿蒙手机', NULL, NULL, '[{\"spec_value_id\":188,\"spec_id\":1,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"}]', '2021-10-15 17:50:26', '2021-10-15 18:51:12');
COMMIT;

-- ----------------------------
-- Table structure for es_as_log
-- ----------------------------
DROP TABLE IF EXISTS `es_as_log`;
CREATE TABLE `es_as_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `sn` varchar(50) DEFAULT NULL COMMENT '售后/退款编号',
  `log_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `log_detail` longtext COMMENT '详细信息',
  `operator` varchar(255) DEFAULT NULL COMMENT '操作者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SN` (`sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1443161088068698119 DEFAULT CHARSET=utf8 COMMENT='售后服务日志记录表(es_as_log)';

-- ----------------------------
-- Records of es_as_log
-- ----------------------------
BEGIN;
INSERT INTO `es_as_log` VALUES (1443158816177807362, 'AS192164881809014786', 1632910849, '申请售后服务的商品已寄出，等待商家收货。', 'buy001', NULL, NULL);
INSERT INTO `es_as_log` VALUES (1443161088068698114, 'AS192164881809014786', 1632911390, '商家已成功将申请售后服务的商品入库，请等待商家进行退款。', '儒猿技术窝', NULL, NULL);
INSERT INTO `es_as_log` VALUES (1443161088068698115, 'AS197966109935661057', 1634291426, '售后服务单已申请成功，等待售后审核中。', 'buy001', '2021-10-15 17:50:26', '2021-10-15 17:50:26');
INSERT INTO `es_as_log` VALUES (1443161088068698116, 'AS197966109935661057', 1634292768, '售后服务申请已通过商家审核。', '儒猿技术窝', '2021-10-15 18:12:49', '2021-10-15 18:12:49');
INSERT INTO `es_as_log` VALUES (1443161088068698117, 'AS197966109935661057', 1634293155, '申请售后服务的商品已寄出，等待商家收货。', 'buy001', '2021-10-15 18:19:15', '2021-10-15 18:19:15');
INSERT INTO `es_as_log` VALUES (1443161088068698118, 'AS197966109935661057', 1634295072, '商家已成功将申请售后服务的商品入库，请等待商家进行退款。', '儒猿技术窝', '2021-10-15 18:51:12', '2021-10-15 18:51:12');
COMMIT;

-- ----------------------------
-- Table structure for es_as_order
-- ----------------------------
DROP TABLE IF EXISTS `es_as_order`;
CREATE TABLE `es_as_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `sn` varchar(50) DEFAULT NULL COMMENT '售后单号',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `member_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `member_name` varchar(100) DEFAULT NULL COMMENT '用户名',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '商家ID',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '商家名称',
  `mobile` varchar(50) DEFAULT NULL COMMENT '手机号',
  `service_type` varchar(50) DEFAULT NULL COMMENT '售后类型 RETURN_GOODS：退货，CHANGE_GOODS：换货，SUPPLY_AGAIN_GOODS：补发货品，ORDER_CANCEL：取消订单（订单已付款且未收货之前）',
  `service_status` varchar(50) DEFAULT NULL COMMENT '售后单状态 APPLY：待审核，PASS：审核通过，REFUSE：审核拒绝，WAIT_FOR_MANUAL：待人工处理，STOCK_IN：退货入库，REFUNDING：退款中，REFUNDFAIL：退款失败，COMPLETE：完成',
  `reason` varchar(255) DEFAULT NULL COMMENT '申请原因',
  `apply_vouchers` varchar(255) DEFAULT NULL COMMENT '申请凭证',
  `problem_desc` longtext COMMENT '问题描述',
  `goods_json` longtext COMMENT '售后商品信息json',
  `disabled` varchar(50) DEFAULT NULL COMMENT '删除状态 DELETED：已删除 NORMAL：正常',
  `audit_remark` varchar(255) DEFAULT NULL COMMENT '商家审核备注',
  `stock_remark` varchar(255) DEFAULT NULL COMMENT '商家入库备注',
  `refund_remark` varchar(255) DEFAULT NULL COMMENT '平台退款备注',
  `close_reason` varchar(255) DEFAULT NULL COMMENT '取消原因',
  `return_addr` varchar(500) DEFAULT NULL COMMENT '退货地址信息',
  `new_order_sn` varchar(255) DEFAULT NULL COMMENT '新订单编号',
  `create_channel` varchar(255) DEFAULT NULL COMMENT '售后服务单创建渠道 NORMAL：正常渠道创建，PINTUAN：拼团失败自动创建',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SN` (`sn`) USING BTREE,
  KEY `IDX_ORDER_SN` (`order_sn`) USING BTREE,
  KEY `IDX_MEMBER_ID` (`member_id`) USING BTREE,
  KEY `IDX_SELLER_ID` (`seller_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='售后服务单表(es_as_order)';

-- ----------------------------
-- Records of es_as_order
-- ----------------------------
BEGIN;
INSERT INTO `es_as_order` VALUES (1, 'AS197966109935661057', '197634705833852934', 100, 'buy001', 1, '儒猿技术窝', '13333333333', 'RETURN_GOODS', 'STOCK_IN', '商品与页面描述不符', '不想要了', '34134124', '[{\"goods_id\":1417677439226580994,\"sku_id\":1417746396428079105,\"price\":6550.0,\"ship_num\":1,\"return_num\":1,\"goods_name\":\"鸿蒙手机\",\"goods_image\":null}]', 'NORMAL', '同意', NULL, NULL, NULL, '收货人：李四，联系方式：13333333333，地址：北京密云区城区以外 测试地址', NULL, 'NORMAL', '2021-10-15 17:50:26', '2021-10-15 18:51:12');
COMMIT;

-- ----------------------------
-- Table structure for es_as_refund
-- ----------------------------
DROP TABLE IF EXISTS `es_as_refund`;
CREATE TABLE `es_as_refund` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `service_sn` varchar(50) DEFAULT NULL COMMENT '售后服务单号',
  `refund_price` decimal(20,2) DEFAULT NULL COMMENT '申请的退款金额',
  `agree_price` decimal(20,2) DEFAULT NULL COMMENT '商家同意的退款金额',
  `actual_price` decimal(20,2) DEFAULT NULL COMMENT '实际退款金额',
  `refund_way` varchar(255) DEFAULT NULL COMMENT '退款方式 ORIGINAL：原路退回，OFFLINE：线下支付',
  `account_type` varchar(255) DEFAULT NULL COMMENT '账号类型',
  `return_account` varchar(255) DEFAULT NULL COMMENT '退款账号',
  `bank_name` varchar(255) DEFAULT NULL COMMENT '银行名称',
  `bank_account_number` varchar(255) DEFAULT NULL COMMENT '银行账户',
  `bank_account_name` varchar(255) DEFAULT NULL COMMENT '银行开户名',
  `bank_deposit_name` varchar(255) DEFAULT NULL COMMENT '开户行',
  `pay_order_no` varchar(255) DEFAULT NULL COMMENT '订单支付方式返回的交易号',
  `refund_time` bigint(20) DEFAULT NULL COMMENT '退款时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SERVICE_SN` (`service_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='售后服务退款相关信息表(es_as_refund)';

-- ----------------------------
-- Records of es_as_refund
-- ----------------------------
BEGIN;
INSERT INTO `es_as_refund` VALUES (1, 'AS197966109935661057', 6550.00, 6550.00, NULL, 'BALANCE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-10-15 17:50:26', '2021-10-15 18:12:49');
COMMIT;

-- ----------------------------
-- Table structure for es_goods_snapshot
-- ----------------------------
DROP TABLE IF EXISTS `es_goods_snapshot`;
CREATE TABLE `es_goods_snapshot` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `sn` varchar(255) DEFAULT NULL COMMENT '商品编号',
  `brand_name` varchar(255) DEFAULT NULL COMMENT '品牌名称',
  `category_name` varchar(255) DEFAULT NULL COMMENT '分类名称',
  `goods_type` varchar(20) DEFAULT NULL COMMENT '商品类型',
  `weight` decimal(10,2) DEFAULT NULL COMMENT '重量',
  `intro` longtext COMMENT '商品详情',
  `mobile_intro` longtext COMMENT '商品移动端详情',
  `price` decimal(10,2) DEFAULT NULL COMMENT '商品价格',
  `cost` decimal(10,2) DEFAULT NULL COMMENT '商品成本价',
  `mktprice` decimal(10,2) DEFAULT NULL COMMENT '商品市场价',
  `have_spec` smallint(1) DEFAULT NULL COMMENT '商品是否开启规格1 开启 0 未开启',
  `params_json` longtext COMMENT '参数json',
  `img_json` longtext COMMENT '图片json',
  `point` int(10) DEFAULT NULL COMMENT '商品使用积分',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '所属卖家',
  `promotion_json` longtext COMMENT '促销json值',
  `coupon_json` longtext COMMENT '优惠券json值',
  `member_id` bigint(20) NOT NULL COMMENT '会员id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_GOODS_SNAPSHOT` (`id`,`goods_id`,`sn`,`goods_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1443027489599254531 DEFAULT CHARSET=utf8 COMMENT='交易快照(es_goods_snapshot)';

-- ----------------------------
-- Records of es_goods_snapshot
-- ----------------------------
BEGIN;
INSERT INTO `es_goods_snapshot` VALUES (1443027489599254530, 1417677439226580994, '鸿蒙手机', 'hm-01', '华为', '手机', 'NORMAL', 1.00, '<p>华为自研操作系统鸿蒙os<br></p>', '', 6550.00, 6350.00, 6233.00, 1, '[{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":718,\"param_name\":\"型号\",\"param_value\":\"鸿蒙\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":205,\"is_index\":1,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":719,\"param_name\":\"上市时间\",\"param_value\":\"2021-07-21\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":205,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"主体\",\"group_id\":205},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":720,\"param_name\":\"颜色\",\"param_value\":\"黑色、红色、白色\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":206,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":721,\"param_name\":\"外形尺寸\",\"param_value\":\"1000*1000\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":206,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"外观\",\"group_id\":206},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":722,\"param_name\":\"系统版本\",\"param_value\":\"鸿蒙\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":207,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":723,\"param_name\":\"手机操作系统\",\"param_value\":\"鸿蒙os\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":207,\"is_index\":1,\"option_list\":[\"\"]}],\"group_name\":\"系统\",\"group_id\":207},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":724,\"param_name\":\"CPU型号\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":208,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":725,\"param_name\":\"CPU频率\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":208,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":726,\"param_name\":\"CPU核数\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":208,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"CPU\",\"group_id\":208},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":727,\"param_name\":\"4G网络制式\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":209,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":728,\"param_name\":\"3G网络制式\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":209,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":729,\"param_name\":\"2G网络制式\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":209,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":730,\"param_name\":\"待机模式\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":209,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":731,\"param_name\":\"SIM卡尺寸\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":209,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"网络\",\"group_id\":209},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":732,\"param_name\":\"机身内存\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":210,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":733,\"param_name\":\"运行内存\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":210,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":734,\"param_name\":\"存储卡类型\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":210,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":735,\"param_name\":\"最大存储扩展\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":210,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"存储\",\"group_id\":210},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":736,\"param_name\":\"屏幕材质\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":211,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":737,\"param_name\":\"屏幕尺寸\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":211,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":738,\"param_name\":\"屏幕分辨率\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":211,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"屏幕\",\"group_id\":211},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":739,\"param_name\":\"摄像头类型\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":212,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":740,\"param_name\":\"前摄像头\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":212,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":741,\"param_name\":\"后摄像头\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":212,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":742,\"param_name\":\"闪光灯类型\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":212,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":743,\"param_name\":\"传感器类型\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":212,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":744,\"param_name\":\"变焦模式\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":212,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"拍照\",\"group_id\":212},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":745,\"param_name\":\"电池类型\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":213,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":746,\"param_name\":\"无线充电\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":213,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":747,\"param_name\":\"快充功能\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":213,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":748,\"param_name\":\"电池更换\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":213,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"电池\",\"group_id\":213},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":749,\"param_name\":\"蓝牙版本\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":214,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":750,\"param_name\":\"NFC（近场通讯）\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":214,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":751,\"param_name\":\"耳机接口\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":214,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":752,\"param_name\":\"数据线\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":214,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"接口\",\"group_id\":214},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":753,\"param_name\":\"重力传感器\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":215,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":754,\"param_name\":\"光线传感器\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":215,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":755,\"param_name\":\"距离传感器\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":215,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":756,\"param_name\":\"陀螺仪\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":215,\"is_index\":0,\"option_list\":[\"\"]},{\"id\":null,\"goods_id\":null,\"param_id\":757,\"param_name\":\"指纹识别\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":215,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"手机特性\",\"group_id\":215},{\"params\":[{\"id\":null,\"goods_id\":null,\"param_id\":758,\"param_name\":\"运营商标识\",\"param_value\":\"\",\"param_type\":1,\"options\":\"\",\"required\":0,\"group_id\":216,\"is_index\":0,\"option_list\":[\"\"]}],\"group_name\":\"其他\",\"group_id\":216}]', '[{\"img_id\":1417677440279351297,\"goods_id\":1417677439226580994,\"thumbnail\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_300x300\",\"small\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_400x400\",\"big\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_800x800\",\"original\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg\",\"tiny\":null,\"isdefault\":1,\"sort\":0}]', NULL, 1, '[]', '[]', 2, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for es_order
-- ----------------------------
DROP TABLE IF EXISTS `es_order`;
CREATE TABLE `es_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `trade_sn` varchar(20) DEFAULT NULL COMMENT '交易编号',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '店铺ID',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '店铺名称',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `member_name` varchar(255) DEFAULT NULL COMMENT '买家账号',
  `order_status` varchar(50) DEFAULT NULL COMMENT '订单状态',
  `pay_status` varchar(50) DEFAULT NULL COMMENT '付款状态',
  `ship_status` varchar(50) DEFAULT NULL COMMENT '货运状态',
  `shipping_id` bigint(20) DEFAULT NULL COMMENT '配送方式ID',
  `comment_status` varchar(50) DEFAULT NULL COMMENT '评论是否完成',
  `shipping_type` varchar(255) DEFAULT NULL COMMENT '配送方式',
  `payment_method_id` bigint(20) DEFAULT NULL COMMENT '支付方式id',
  `payment_plugin_id` varchar(50) DEFAULT NULL COMMENT '支付插件id',
  `payment_method_name` varchar(50) DEFAULT NULL COMMENT '支付方式名称',
  `payment_type` varchar(50) DEFAULT NULL COMMENT '支付方式类型',
  `payment_time` bigint(20) DEFAULT NULL COMMENT '支付时间',
  `pay_money` decimal(20,2) DEFAULT NULL COMMENT '已支付金额',
  `ship_name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
  `ship_addr` varchar(255) DEFAULT NULL COMMENT '收货地址',
  `ship_zip` varchar(20) DEFAULT NULL COMMENT '收货人邮编',
  `ship_mobile` varchar(50) DEFAULT NULL COMMENT '收货人手机',
  `ship_tel` varchar(50) DEFAULT NULL COMMENT '收货人电话',
  `receive_time` varchar(50) DEFAULT NULL COMMENT '收货时间',
  `ship_province_id` bigint(20) DEFAULT NULL COMMENT '配送地区-省份ID',
  `ship_city_id` bigint(20) DEFAULT NULL COMMENT '配送地区-城市ID',
  `ship_county_id` bigint(20) DEFAULT NULL COMMENT '配送地区-区(县)ID',
  `ship_town_id` bigint(20) DEFAULT NULL COMMENT '配送街道id',
  `ship_province` varchar(50) DEFAULT NULL COMMENT '配送地区-省份',
  `ship_city` varchar(50) DEFAULT NULL COMMENT '配送地区-城市',
  `ship_county` varchar(50) DEFAULT NULL COMMENT '配送地区-区(县)',
  `ship_town` varchar(50) DEFAULT NULL COMMENT '配送街道',
  `order_price` decimal(20,2) DEFAULT NULL COMMENT '订单总额',
  `goods_price` decimal(20,2) DEFAULT NULL COMMENT '商品总额',
  `shipping_price` decimal(20,2) DEFAULT NULL COMMENT '配送费用',
  `discount_price` decimal(20,2) DEFAULT NULL COMMENT '优惠金额',
  `disabled` int(1) DEFAULT NULL COMMENT '是否被删除',
  `weight` decimal(20,2) DEFAULT NULL COMMENT '订单商品总重量',
  `goods_num` int(10) DEFAULT NULL COMMENT '商品数量',
  `remark` varchar(1000) DEFAULT NULL COMMENT '订单备注',
  `cancel_reason` varchar(255) DEFAULT NULL COMMENT '订单取消原因',
  `the_sign` varchar(255) DEFAULT NULL COMMENT '签收人',
  `items_json` longtext COMMENT '货物列表json',
  `warehouse_id` int(10) DEFAULT NULL COMMENT '发货仓库ID',
  `need_pay_money` decimal(20,2) DEFAULT NULL COMMENT '应付金额',
  `ship_no` varchar(255) DEFAULT NULL COMMENT '发货单号',
  `address_id` bigint(20) DEFAULT NULL COMMENT '收货地址ID',
  `admin_remark` int(50) DEFAULT NULL COMMENT '管理员备注',
  `logi_id` bigint(20) DEFAULT NULL COMMENT '物流公司ID',
  `logi_name` varchar(255) DEFAULT NULL COMMENT '物流公司名称',
  `complete_time` bigint(20) DEFAULT NULL COMMENT '完成时间',
  `signing_time` bigint(20) DEFAULT NULL COMMENT '签收时间',
  `ship_time` bigint(20) DEFAULT NULL COMMENT '送货时间',
  `pay_order_no` varchar(50) DEFAULT NULL COMMENT '支付方式返回的交易号',
  `service_status` varchar(50) DEFAULT NULL COMMENT '售后状态',
  `bill_status` int(10) DEFAULT NULL COMMENT '结算状态',
  `bill_sn` varchar(50) DEFAULT NULL COMMENT '结算单号',
  `client_type` varchar(50) DEFAULT NULL COMMENT '订单来源',
  `sn` varchar(20) DEFAULT NULL COMMENT '订单编号',
  `need_receipt` int(1) DEFAULT NULL COMMENT '是否需要发票',
  `order_type` varchar(50) DEFAULT 'normal' COMMENT '订单类型',
  `order_data` text COMMENT '订单数据',
  `balance` decimal(20,2) DEFAULT '0.00' COMMENT '预存款抵扣金额',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_ORDER_SN` (`sn`) USING BTREE,
  KEY `IDX_ORDRR_MEMBERID` (`member_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1443437256336474119 DEFAULT CHARSET=utf8 COMMENT='订单表(es_order)';

-- ----------------------------
-- Records of es_order
-- ----------------------------
BEGIN;
INSERT INTO `es_order` VALUES (1443437256336474114, '192453990099845121', 1, '儒猿技术窝', 100, 'buy001', 'PAID_OFF', 'PAY_YES', 'SHIP_NO', NULL, 'UNFINISHED', NULL, NULL, NULL, '预存款', 'ONLINE', 1632977686, NULL, '测试', '测试地址', NULL, '13333333333', '', '任意时间', 2, 2813, 51976, NULL, '上海', '徐汇区', '城区', '', 6550.00, 6550.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, '[{\"seller_id\":1,\"seller_name\":\"儒猿技术窝\",\"goods_id\":1417677439226580994,\"sku_id\":1417746396428079105,\"sku_sn\":\"hm-01-000001\",\"cat_id\":497,\"num\":1,\"goods_weight\":1.0,\"original_price\":6550.0,\"purchase_price\":6550.0,\"subtotal\":6550.0,\"name\":\"鸿蒙手机\",\"goods_image\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_300x300\",\"spec_list\":[{\"spec_id\":null,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null,\"spec_value_id\":188},{\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null,\"spec_value_id\":1417744797169324033}],\"point\":0,\"snapshot_id\":null,\"service_status\":\"NOT_APPLY\",\"complain_status\":\"NO_APPLY\",\"complain_id\":null,\"single_list\":null,\"group_list\":[],\"goods_operate_allowable_vo\":null,\"promotion_tags\":[],\"promotion_type\":null,\"purchase_num\":0,\"actual_pay_total\":6550.0}]', NULL, 0.00, NULL, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NOT_APPLY', NULL, NULL, 'PC', '192453990171279362', 0, 'NORMAL', NULL, 6550.00, NULL, NULL);
INSERT INTO `es_order` VALUES (1443437256336474115, '197515336692662273', 1, '儒猿技术窝', 100, 'buy001', 'PAID_OFF', 'PAY_YES', 'SHIP_NO', NULL, 'UNFINISHED', NULL, NULL, NULL, '预存款', 'ONLINE', 1634184025, NULL, '测试', '测试地址', NULL, '13333333333', '', '任意时间', 2, 2813, 51976, NULL, '上海', '徐汇区', '城区', '', 6550.00, 6550.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, '[{\"seller_id\":1,\"seller_name\":\"儒猿技术窝\",\"goods_id\":1417677439226580994,\"sku_id\":1417746396428079105,\"sku_sn\":\"hm-01-000001\",\"cat_id\":497,\"num\":1,\"goods_weight\":1.0,\"original_price\":6550.0,\"purchase_price\":6550.0,\"subtotal\":6550.0,\"name\":\"鸿蒙手机\",\"goods_image\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_300x300\",\"spec_list\":[{\"spec_value_id\":188,\"spec_id\":null,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null}],\"point\":0,\"snapshot_id\":null,\"service_status\":\"NOT_APPLY\",\"complain_status\":\"NO_APPLY\",\"complain_id\":null,\"single_list\":null,\"group_list\":[],\"goods_operate_allowable_vo\":null,\"promotion_tags\":[],\"promotion_type\":null,\"purchase_num\":0,\"actual_pay_total\":6550.0}]', NULL, 0.00, NULL, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NOT_APPLY', NULL, NULL, 'PC', '197515336768290818', 0, 'NORMAL', NULL, 6550.00, NULL, NULL);
INSERT INTO `es_order` VALUES (1443437256336474116, '197634613949104129', 1, '儒猿技术窝', 100, 'buy001', 'NEW', 'PAY_NO', 'SHIP_NO', NULL, 'UNFINISHED', NULL, NULL, NULL, NULL, 'ONLINE', NULL, NULL, '测试', '测试地址', NULL, '13333333333', '', '任意时间', 2, 2813, 51976, NULL, '上海', '徐汇区', '城区', '', 6550.00, 6550.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, '[{\"seller_id\":1,\"seller_name\":\"儒猿技术窝\",\"goods_id\":1417677439226580994,\"sku_id\":1417746396428079105,\"sku_sn\":\"hm-01-000001\",\"cat_id\":497,\"num\":1,\"goods_weight\":1.0,\"original_price\":6550.0,\"purchase_price\":6550.0,\"subtotal\":6550.0,\"name\":\"鸿蒙手机\",\"goods_image\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_300x300\",\"spec_list\":[{\"spec_value_id\":188,\"spec_id\":null,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null}],\"point\":0,\"snapshot_id\":null,\"service_status\":\"NOT_APPLY\",\"complain_status\":\"NO_APPLY\",\"complain_id\":null,\"single_list\":null,\"group_list\":[],\"goods_operate_allowable_vo\":null,\"promotion_tags\":[],\"promotion_type\":null,\"purchase_num\":0,\"actual_pay_total\":6550.0}]', NULL, 6550.00, NULL, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NOT_APPLY', NULL, NULL, 'PC', '197634613986983938', 0, 'NORMAL', NULL, 0.00, '2021-10-14 19:53:11', '2021-10-14 19:53:11');
INSERT INTO `es_order` VALUES (1443437256336474117, '197634694412632067', 1, '儒猿技术窝', 100, 'buy001', 'NEW', 'PAY_NO', 'SHIP_NO', NULL, 'UNFINISHED', NULL, NULL, NULL, NULL, 'ONLINE', NULL, NULL, '测试', '测试地址', NULL, '13333333333', '', '任意时间', 2, 2813, 51976, NULL, '上海', '徐汇区', '城区', '', 6550.00, 6550.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, '[{\"seller_id\":1,\"seller_name\":\"儒猿技术窝\",\"goods_id\":1417677439226580994,\"sku_id\":1417746396428079105,\"sku_sn\":\"hm-01-000001\",\"cat_id\":497,\"num\":1,\"goods_weight\":1.0,\"original_price\":6550.0,\"purchase_price\":6550.0,\"subtotal\":6550.0,\"name\":\"鸿蒙手机\",\"goods_image\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_300x300\",\"spec_list\":[{\"spec_value_id\":188,\"spec_id\":null,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null}],\"point\":0,\"snapshot_id\":null,\"service_status\":\"NOT_APPLY\",\"complain_status\":\"NO_APPLY\",\"complain_id\":null,\"single_list\":null,\"group_list\":[],\"goods_operate_allowable_vo\":null,\"promotion_tags\":[],\"promotion_type\":null,\"purchase_num\":0,\"actual_pay_total\":6550.0}]', NULL, 6550.00, NULL, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NOT_APPLY', NULL, NULL, 'PC', '197634694412763140', 0, 'NORMAL', NULL, 0.00, '2021-10-14 19:53:30', '2021-10-14 19:53:30');
INSERT INTO `es_order` VALUES (1443437256336474118, '197634705833721861', 1, '儒猿技术窝', 100, 'buy001', 'ROG', 'PAY_YES', 'SHIP_ROG', NULL, 'UNFINISHED', NULL, NULL, NULL, '预存款', 'ONLINE', 1634212644, NULL, '测试', '测试地址', NULL, '13333333333', '', '任意时间', 2, 2813, 51976, NULL, '上海', '徐汇区', '城区', '', 6550.00, 6550.00, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, '[{\"seller_id\":1,\"seller_name\":\"儒猿技术窝\",\"goods_id\":1417677439226580994,\"sku_id\":1417746396428079105,\"sku_sn\":\"hm-01-000001\",\"cat_id\":497,\"num\":1,\"goods_weight\":1.0,\"original_price\":6550.0,\"purchase_price\":6550.0,\"subtotal\":6550.0,\"name\":\"鸿蒙手机\",\"goods_image\":\"http://javashop-01.oss-cn-shanghai.aliyuncs.com/javashop/goods/BEF25E136AE049D481770A703340D286.jpeg_300x300\",\"spec_list\":[{\"spec_value_id\":188,\"spec_id\":null,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":null,\"spec_image\":null}],\"point\":0,\"snapshot_id\":null,\"service_status\":\"APPLY\",\"complain_status\":\"NO_APPLY\",\"complain_id\":null,\"single_list\":null,\"group_list\":[],\"goods_operate_allowable_vo\":null,\"promotion_tags\":[],\"promotion_type\":null,\"purchase_num\":0,\"actual_pay_total\":6550.0}]', NULL, 0.00, NULL, 27, NULL, NULL, NULL, NULL, 1634290144, 1634289425, NULL, 'EXPIRED', NULL, NULL, 'PC', '197634705833852934', 0, 'NORMAL', NULL, 6550.00, '2021-10-14 19:53:33', '2021-10-14 19:53:33');
COMMIT;

-- ----------------------------
-- Table structure for es_order_complain
-- ----------------------------
DROP TABLE IF EXISTS `es_order_complain`;
CREATE TABLE `es_order_complain` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `complain_topic` varchar(50) DEFAULT NULL COMMENT '投诉主题',
  `content` longtext COMMENT '投诉内容',
  `images` longtext COMMENT '投诉凭证图片',
  `status` varchar(50) DEFAULT NULL COMMENT '状态，见ComplainStatusEnum.java',
  `appeal_content` longtext COMMENT '商家申诉内容',
  `appeal_time` bigint(20) DEFAULT NULL COMMENT '商家申诉时间',
  `appeal_images` longtext COMMENT '商家申诉上传的图片',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单号',
  `order_time` bigint(20) DEFAULT NULL COMMENT '下单时间',
  `goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `goods_price` decimal(10,2) DEFAULT NULL COMMENT '商品价格',
  `num` int(10) DEFAULT NULL COMMENT '购买的商品数量',
  `shipping_price` decimal(10,2) DEFAULT NULL COMMENT '运费',
  `order_price` decimal(10,2) DEFAULT NULL COMMENT '订单金额',
  `ship_no` varchar(50) DEFAULT NULL COMMENT '物流单号',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '商家id',
  `seller_name` varchar(100) DEFAULT NULL COMMENT '商家名称',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(100) DEFAULT NULL COMMENT '会员名称',
  `ship_name` varchar(50) DEFAULT NULL COMMENT '收货人',
  `ship_addr` varchar(255) DEFAULT NULL COMMENT '收货地址',
  `ship_mobile` varchar(50) DEFAULT NULL COMMENT '收货人手机',
  `arbitration_result` longtext COMMENT '仲裁结果',
  `sku_id` bigint(20) DEFAULT NULL COMMENT 'sku 主键',
  `goods_image` varchar(255) DEFAULT NULL COMMENT '商品图片',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_ORDER_COMPLAIN` (`id`,`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for es_order_complain_communication
-- ----------------------------
DROP TABLE IF EXISTS `es_order_complain_communication`;
CREATE TABLE `es_order_complain_communication` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `complain_id` bigint(20) DEFAULT NULL COMMENT '投诉id',
  `content` longtext COMMENT '对话内容',
  `owner` varchar(50) DEFAULT NULL COMMENT '所属，买家/卖家',
  `owner_name` varchar(100) DEFAULT NULL COMMENT '对话所属名称',
  `owner_id` bigint(20) DEFAULT NULL COMMENT '对话所属id,卖家id/买家id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_ORDER_COMPLAIN_COMMUNICATION` (`id`,`complain_id`,`owner_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for es_order_items
-- ----------------------------
DROP TABLE IF EXISTS `es_order_items`;
CREATE TABLE `es_order_items` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品ID',
  `product_id` bigint(20) DEFAULT NULL COMMENT '货品ID',
  `num` int(10) DEFAULT NULL COMMENT '销售量',
  `ship_num` int(10) DEFAULT NULL COMMENT '发货量',
  `trade_sn` varchar(50) DEFAULT NULL COMMENT '交易编号',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `image` varchar(255) DEFAULT NULL COMMENT '图片',
  `name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `price` decimal(20,2) DEFAULT NULL COMMENT '销售金额',
  `cat_id` bigint(20) DEFAULT NULL COMMENT '分类ID',
  `state` int(1) DEFAULT NULL COMMENT '状态',
  `snapshot_id` bigint(20) DEFAULT NULL COMMENT '快照id',
  `spec_json` varchar(1000) DEFAULT NULL COMMENT '规格json',
  `promotion_type` varchar(255) DEFAULT NULL COMMENT '促销类型',
  `promotion_id` bigint(20) DEFAULT NULL COMMENT '促销id',
  `refund_price` decimal(20,2) DEFAULT NULL COMMENT '订单项可退款金额',
  `comment_status` varchar(255) DEFAULT 'UNFINISHED' COMMENT '评论状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_ORDER_SN` (`order_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1443437256382611463 DEFAULT CHARSET=utf8 COMMENT='订单货物表(es_order_items)';

-- ----------------------------
-- Records of es_order_items
-- ----------------------------
BEGIN;
INSERT INTO `es_order_items` VALUES (1443437256382611458, 1417677439226580994, 1417746396428079105, 1, NULL, '192453990099845121', '192453990171279362', NULL, '鸿蒙手机', 6550.00, 497, NULL, NULL, '[{\"spec_id\":1,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\",\"spec_value_id\":188},{\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\",\"spec_value_id\":1417744797169324033}]', NULL, NULL, 6550.00, 'UNFINISHED', NULL, NULL);
INSERT INTO `es_order_items` VALUES (1443437256382611459, 1417677439226580994, 1417746396428079105, 1, NULL, '197515336692662273', '197515336768290818', NULL, '鸿蒙手机', 6550.00, 497, NULL, NULL, '[{\"spec_value_id\":188,\"spec_id\":1,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"}]', NULL, NULL, 6550.00, 'UNFINISHED', NULL, NULL);
INSERT INTO `es_order_items` VALUES (1443437256382611460, 1417677439226580994, 1417746396428079105, 1, NULL, '197634613949104129', '197634613986983938', NULL, '鸿蒙手机', 6550.00, 497, NULL, NULL, '[{\"spec_value_id\":188,\"spec_id\":1,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"}]', NULL, NULL, 6550.00, 'UNFINISHED', '2021-10-14 19:53:11', '2021-10-14 19:53:11');
INSERT INTO `es_order_items` VALUES (1443437256382611461, 1417677439226580994, 1417746396428079105, 1, NULL, '197634694412632067', '197634694412763140', NULL, '鸿蒙手机', 6550.00, 497, NULL, NULL, '[{\"spec_value_id\":188,\"spec_id\":1,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"}]', NULL, NULL, 6550.00, 'UNFINISHED', '2021-10-14 19:53:30', '2021-10-14 19:53:30');
INSERT INTO `es_order_items` VALUES (1443437256382611462, 1417677439226580994, 1417746396428079105, 1, NULL, '197634705833721861', '197634705833852934', NULL, '鸿蒙手机', 6550.00, 497, NULL, NULL, '[{\"spec_value_id\":188,\"spec_id\":1,\"spec_value\":\"黄色\",\"seller_id\":null,\"spec_name\":\"颜色\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"},{\"spec_value_id\":1417744797169324033,\"spec_id\":1417744751111671809,\"spec_value\":\"8+128\",\"seller_id\":null,\"spec_name\":\"存储容量\",\"sku_id\":null,\"big\":null,\"small\":null,\"thumbnail\":null,\"tiny\":null,\"spec_type\":0,\"spec_image\":\"\"}]', NULL, NULL, 6550.00, 'UNFINISHED', '2021-10-14 19:53:33', '2021-10-14 19:53:33');
COMMIT;

-- ----------------------------
-- Table structure for es_order_log
-- ----------------------------
DROP TABLE IF EXISTS `es_order_log`;
CREATE TABLE `es_order_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `op_id` bigint(20) DEFAULT NULL COMMENT '操作者id',
  `op_name` varchar(100) DEFAULT NULL COMMENT '操作者名称',
  `message` varchar(100) DEFAULT NULL COMMENT '日志信息',
  `op_time` bigint(20) DEFAULT NULL COMMENT '操作时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_ORDER_SN` (`order_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='订单日志表(es_order_log)';

-- ----------------------------
-- Records of es_order_log
-- ----------------------------
BEGIN;
INSERT INTO `es_order_log` VALUES (1, '197634705833852934', NULL, '店铺:平台自营', '订单发货', 1634289425, '2021-10-15 17:17:05', '2021-10-15 17:17:05');
INSERT INTO `es_order_log` VALUES (2, '197634705833852934', NULL, 'buy001', '确认收货', 1634290144, '2021-10-15 17:29:04', '2021-10-15 17:29:04');
COMMIT;

-- ----------------------------
-- Table structure for es_order_meta
-- ----------------------------
DROP TABLE IF EXISTS `es_order_meta`;
CREATE TABLE `es_order_meta` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单编号',
  `meta_key` varchar(255) DEFAULT NULL COMMENT '扩展-键',
  `meta_value` longtext COMMENT '扩展-值',
  `status` varchar(50) DEFAULT NULL COMMENT '售后状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单扩展信息表(es_order_meta)';

-- ----------------------------
-- Table structure for es_order_out_status
-- ----------------------------
DROP TABLE IF EXISTS `es_order_out_status`;
CREATE TABLE `es_order_out_status` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_sn` varchar(20) DEFAULT NULL COMMENT '订单编号',
  `out_type` varchar(20) DEFAULT NULL COMMENT '出库类型',
  `out_status` varchar(20) DEFAULT NULL COMMENT '出库状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单出库状态(es_order_out_status)';

-- ----------------------------
-- Table structure for es_refund
-- ----------------------------
DROP TABLE IF EXISTS `es_refund`;
CREATE TABLE `es_refund` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `sn` varchar(50) DEFAULT NULL COMMENT '售后服务单号',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员id',
  `member_name` varchar(255) DEFAULT NULL COMMENT '会员名称',
  `seller_id` bigint(20) DEFAULT NULL COMMENT '卖家id',
  `seller_name` varchar(255) DEFAULT NULL COMMENT '卖家姓名',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `refund_status` varchar(50) DEFAULT NULL COMMENT '退款单状态 APPLY：新创建，REFUNDING：退款中，REFUNDFAIL：退款失败，COMPLETE：完成',
  `refund_price` decimal(20,2) DEFAULT NULL COMMENT '申请退款金额',
  `refund_way` varchar(50) DEFAULT NULL COMMENT '退款方式 ORIGINAL：原路退回，OFFLINE：线下退款，ACCOUNT：账户退款',
  `account_type` varchar(50) DEFAULT NULL COMMENT '退款账户类型',
  `return_account` varchar(255) DEFAULT NULL COMMENT '退款账户',
  `bank_name` varchar(255) DEFAULT NULL COMMENT '银行名称',
  `bank_account_number` varchar(255) DEFAULT NULL COMMENT '银行账号',
  `bank_account_name` varchar(255) DEFAULT NULL COMMENT '银行开户名',
  `bank_deposit_name` varchar(255) DEFAULT NULL COMMENT '银行开户行',
  `pay_order_no` varchar(255) DEFAULT NULL COMMENT '支付结果交易号',
  `payment_type` varchar(50) DEFAULT NULL COMMENT '订单付款类型 ONLINE：在线支付，COD：货到付款',
  `refund_fail_reason` varchar(255) DEFAULT NULL COMMENT '退款失败原因',
  `refund_time` bigint(20) DEFAULT NULL COMMENT '退款时间',
  `mobile` varchar(50) DEFAULT NULL COMMENT '手机号',
  `agree_price` decimal(20,2) DEFAULT NULL COMMENT '商家同意的退款金额',
  `actual_price` decimal(20,2) DEFAULT NULL COMMENT '实际退款金额',
  `goods_json` longtext COMMENT '售后商品信息json',
  `disabled` varchar(20) DEFAULT 'NORMAL' COMMENT '删除状态 DELETED：已删除 NORMAL：正常',
  `create_channel` varchar(255) DEFAULT NULL COMMENT '售后服务单创建渠道 NORMAL：正常渠道创建，PINTUAN：拼团失败自动创建',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_SN` (`sn`) USING BTREE,
  KEY `IDX_ORDER_SN` (`order_sn`) USING BTREE,
  KEY `IDX_MEMBER_ID` (`member_id`) USING BTREE,
  KEY `IDX_SELLER_ID` (`seller_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='售后服务退款单(es_refund)';

-- ----------------------------
-- Records of es_refund
-- ----------------------------
BEGIN;
INSERT INTO `es_refund` VALUES (1, 'AS197966109935661057', 100, 'buy001', 1, '儒猿技术窝', '197634705833852934', 'APPLY', 6550.00, 'BALANCE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13333333333', 6550.00, NULL, '[{\"goods_id\":1417677439226580994,\"sku_id\":1417746396428079105,\"price\":6550.0,\"ship_num\":1,\"return_num\":1,\"goods_name\":\"鸿蒙手机\",\"goods_image\":null}]', 'NORMAL', 'NORMAL', '2021-10-15 17:50:26', '2021-10-15 17:50:26');
COMMIT;

-- ----------------------------
-- Table structure for es_trade
-- ----------------------------
DROP TABLE IF EXISTS `es_trade`;
CREATE TABLE `es_trade` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'trade_id',
  `trade_sn` varchar(50) DEFAULT NULL COMMENT '交易编号',
  `member_id` bigint(20) DEFAULT NULL COMMENT '买家id',
  `member_name` varchar(100) DEFAULT NULL COMMENT '买家用户名',
  `payment_method_id` bigint(20) DEFAULT NULL COMMENT '支付方式id',
  `payment_plugin_id` varchar(50) DEFAULT NULL COMMENT '支付插件id',
  `payment_method_name` varchar(50) DEFAULT NULL COMMENT '支付方式名称',
  `payment_type` varchar(20) DEFAULT NULL COMMENT '支付方式类型',
  `total_price` decimal(20,2) DEFAULT NULL COMMENT '总价格',
  `goods_price` decimal(20,2) DEFAULT NULL COMMENT '商品价格',
  `freight_price` decimal(20,2) DEFAULT NULL COMMENT '运费',
  `discount_price` decimal(20,2) DEFAULT NULL COMMENT '优惠的金额',
  `consignee_id` bigint(20) DEFAULT NULL COMMENT '收货人id',
  `consignee_name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
  `consignee_country` varchar(50) DEFAULT NULL COMMENT '收货国家',
  `consignee_country_id` bigint(20) DEFAULT NULL COMMENT '收货国家id',
  `consignee_province` varchar(50) DEFAULT NULL COMMENT '收货省',
  `consignee_province_id` bigint(20) DEFAULT NULL COMMENT '收货省id',
  `consignee_city` varchar(50) DEFAULT NULL COMMENT '收货市',
  `consignee_city_id` bigint(20) DEFAULT NULL COMMENT '收货市id',
  `consignee_county` varchar(50) DEFAULT NULL COMMENT '收货区',
  `consignee_county_id` bigint(20) DEFAULT NULL COMMENT '收货区id',
  `consignee_town` varchar(50) DEFAULT NULL COMMENT '收货镇',
  `consignee_town_id` bigint(20) DEFAULT NULL COMMENT '收货镇id',
  `consignee_address` varchar(255) DEFAULT NULL COMMENT '收货详细地址',
  `consignee_mobile` varchar(50) DEFAULT NULL COMMENT '收货人手机号',
  `consignee_telephone` varchar(50) DEFAULT NULL COMMENT '收货人电话',
  `order_json` longtext COMMENT '订单json(预留，7.0可能废弃)',
  `trade_status` varchar(50) DEFAULT NULL COMMENT '订单状态',
  `balance` decimal(20,2) DEFAULT '0.00' COMMENT '预存款抵扣金额',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `IDX_TRADE_SN` (`trade_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1448617971582472194 DEFAULT CHARSET=utf8 COMMENT='交易表(es_trade)';

-- ----------------------------
-- Records of es_trade
-- ----------------------------
BEGIN;
INSERT INTO `es_trade` VALUES (1443437256118370305, '192453990099845121', 100, 'buy001', NULL, NULL, '预存款', 'ONLINE', 0.00, 6550.00, 0.00, 0.00, 27, '测试', NULL, NULL, '上海', 2, '徐汇区', 2813, '城区', 51976, '', NULL, '测试地址', '13333333333', NULL, NULL, 'PAID_OFF', 6550.00, NULL, NULL);
INSERT INTO `es_trade` VALUES (1448498602823094274, '197515336692662273', 100, 'buy001', NULL, NULL, '预存款', 'ONLINE', 0.00, 6550.00, 0.00, 0.00, 27, '测试', NULL, NULL, '上海', 2, '徐汇区', 2813, '城区', 51976, '', NULL, '测试地址', '13333333333', NULL, NULL, 'PAID_OFF', 6550.00, NULL, NULL);
INSERT INTO `es_trade` VALUES (1448617879899181058, '197634613949104129', 100, 'buy001', NULL, NULL, NULL, 'ONLINE', 6550.00, 6550.00, 0.00, 0.00, 27, '测试', NULL, NULL, '上海', 2, '徐汇区', 2813, '城区', 51976, '', NULL, '测试地址', '13333333333', NULL, NULL, 'NEW', 0.00, '2021-10-14 19:53:11', '2021-10-14 19:53:11');
INSERT INTO `es_trade` VALUES (1448617960157188097, '197634694412632067', 100, 'buy001', NULL, NULL, NULL, 'ONLINE', 6550.00, 6550.00, 0.00, 0.00, 27, '测试', NULL, NULL, '上海', 2, '徐汇区', 2813, '城区', 51976, '', NULL, '测试地址', '13333333333', NULL, NULL, 'NEW', 0.00, '2021-10-14 19:53:30', '2021-10-14 19:53:30');
INSERT INTO `es_trade` VALUES (1448617971582472193, '197634705833721861', 100, 'buy001', NULL, NULL, '预存款', 'ONLINE', 0.00, 6550.00, 0.00, 0.00, 27, '测试', NULL, NULL, '上海', 2, '徐汇区', 2813, '城区', 51976, '', NULL, '测试地址', '13333333333', NULL, NULL, 'PAID_OFF', 6550.00, '2021-10-14 19:53:33', '2021-10-14 19:53:33');
COMMIT;

-- ----------------------------
-- Table structure for es_transaction_record
-- ----------------------------
DROP TABLE IF EXISTS `es_transaction_record`;
CREATE TABLE `es_transaction_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `order_sn` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `goods_id` bigint(20) DEFAULT NULL COMMENT '商品ID',
  `goods_num` int(10) DEFAULT NULL COMMENT '商品数量',
  `rog_time` bigint(20) DEFAULT NULL COMMENT '确认收货时间',
  `uname` varchar(50) DEFAULT NULL COMMENT '用户名',
  `price` decimal(20,2) DEFAULT NULL COMMENT '交易价格',
  `member_id` bigint(20) DEFAULT NULL COMMENT '会员ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_goods_id` (`goods_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='交易记录表(es_transaction_record)';

SET FOREIGN_KEY_CHECKS = 1;
